UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dSHz8ppLujyTj+cuexZ/6THnuTO2ndooIY+BjAt/AWs='
WHERE
key_id = 'd5d93b7ba459e9e6a4ef64f75d4805eeed7de54b4737c4e12fbe652b820f6ae6'
AND (
token = 'dSHz8ppLujyTj+cuexZ/6THnuTO2ndooIY+BjAt/AWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)