UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5IC0oEr5YkHsDXQAlkDtmmueac7HmYDU//pzHHk+bCc='
WHERE
key_id = 'cc585980dbaa70a98b10afff5763cc9850a11a50f9dc0a56472e987036142746'
AND (
token = '5IC0oEr5YkHsDXQAlkDtmmueac7HmYDU//pzHHk+bCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)