UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7jgYH/30DeNiDPna1oH4NiPB8vod3cpMuzzPGa+d2ME='
WHERE
key_id = '51847f971e0d4a7edc639498758d183b42dfb7f142c3441a93bfc56a677ff2b8'
AND (
token = '7jgYH/30DeNiDPna1oH4NiPB8vod3cpMuzzPGa+d2ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)