UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rvgj8eRDBX3/a7D4EYFgCGqgkL+XqByZXXDvGi54rHY='
WHERE
key_id = '4ae9fa5093a702c138ba65feabcb3fc75630c6092e125eac3df2cbe21ca3b12a'
AND (
token = 'rvgj8eRDBX3/a7D4EYFgCGqgkL+XqByZXXDvGi54rHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)