UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qF78Hesy7BqPEpoNP+guwMBz9grx0WLzRiq9RFJpOPw='
WHERE
key_id = 'bc1ef50f48dc3cd48f8066cae9ab5a75fafe9123acd320af5bd1c67a60cf6453'
AND (
token = 'qF78Hesy7BqPEpoNP+guwMBz9grx0WLzRiq9RFJpOPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)