UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DSIB09Ug1Owj1+jBQ88vdIEJ0ENJOCsAFZIAaNw89Is='
WHERE
key_id = 'd523af5e17392ea52c62d39c3c58e00eae4b2931c61e1644c3b75ce706ec2522'
AND (
token = 'DSIB09Ug1Owj1+jBQ88vdIEJ0ENJOCsAFZIAaNw89Is='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)