UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8RG8bOgUNoyc4tfPVRW5BEvZHMby3Y7mSZfjnuqWWD4='
WHERE
key_id = 'aeded2a809c1cf62b76ee0a4b1a217759598c99043e2d73ec001e97a14566ae2'
AND (
token = '8RG8bOgUNoyc4tfPVRW5BEvZHMby3Y7mSZfjnuqWWD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)