UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PL8sqCT28QV7232VJLj/rf8tCPeXS5cYUx8cbmNqJaw='
WHERE
key_id = '820029b9b8bcc948c5c3dc63275668e5ab298c5571c3348e42a0bda362c45896'
AND (
token = 'PL8sqCT28QV7232VJLj/rf8tCPeXS5cYUx8cbmNqJaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)