UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g6BwSM/kgjGmXcIEPRCPDnfQgZzdlMJLsw15m9Cl45Q='
WHERE
key_id = '6c5b18ff072cd360aa50787d3f3ce7f153f6f2084ab3b8a43ce87e3d62ea6497'
AND (
token = 'g6BwSM/kgjGmXcIEPRCPDnfQgZzdlMJLsw15m9Cl45Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)