UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eHg6Tf5g4iRqV6TYJTDqBzzCSJ/MuwA773XuV8Wz5gU='
WHERE
key_id = '19a939ebc71b90e93a786e4d68050332f58277e5aa7172a51a24384fdbd449ec'
AND (
token = 'eHg6Tf5g4iRqV6TYJTDqBzzCSJ/MuwA773XuV8Wz5gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)