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