UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UjvG3mZB5QciIa4lxTtntEvy7JCvk2CScKUMp0qqHgo='
WHERE
key_id = 'd1a0150301a4d35d80722ff392f93386787f131c4339ab0e9cfce5dd037713a5'
AND (
token = 'UjvG3mZB5QciIa4lxTtntEvy7JCvk2CScKUMp0qqHgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)