UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H2hGvHowVBltjIEWNj9jWwVwCHF0/0vW2s/5+ZMr6k4='
WHERE
key_id = 'e8862c4d06b72f5a765986a0055dc4be9a2447afb3e0fcc0bb84bf35610b8508'
AND (
token = 'H2hGvHowVBltjIEWNj9jWwVwCHF0/0vW2s/5+ZMr6k4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)