UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lE9OckunVZsY4Rt4iVKU7HM3+LBJRmyZX2WD+Yqpys0='
WHERE
key_id = '4ac7a360f3da1445b20b83801055def0c0c88c562bc1720c6b255ea0d93dcfe5'
AND (
token = 'lE9OckunVZsY4Rt4iVKU7HM3+LBJRmyZX2WD+Yqpys0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)