UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bD6Bn7tBsv0z43U8PiknL03+AoY/Y3AYqlY9cJwotdI='
WHERE
key_id = '8dcb3483d2430eabf58394bde5e3a35cca6cbbee4d3bc167d592665c20593dea'
AND (
token = 'bD6Bn7tBsv0z43U8PiknL03+AoY/Y3AYqlY9cJwotdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)