UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JiVINtd6UgxfRYKIfZMml6RRxyXMWqvRJST06oTIfG8='
WHERE
key_id = '25ab933f1e5804cd86ef7a5e30c3afbeed7396fab1339c9b70b085dc9aa09ee1'
AND (
token = 'JiVINtd6UgxfRYKIfZMml6RRxyXMWqvRJST06oTIfG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)