UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sWZrZ1KiUpswQLCFp71Hm6kFmprgL2ymPtWYBi7jcWw='
WHERE
key_id = '47b830225a0c9773f1f8cda2e6220713d33f422b4864758d5d3d2d2de84746a3'
AND (
token = 'sWZrZ1KiUpswQLCFp71Hm6kFmprgL2ymPtWYBi7jcWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)