UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRKd5ybopvFODdZokTACBt3tPSJsCpUOTzsRQLQLHbU='
WHERE
key_id = '1caef2c809c35898a1b5a99a69386c21c806d0d911aca4d2b972a79589f4a33d'
AND (
token = 'dRKd5ybopvFODdZokTACBt3tPSJsCpUOTzsRQLQLHbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)