UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HExsOz+buTjngWX+7iibXPS16cMk3Pugz+serM/Yomg='
WHERE
key_id = '03f232c27b40f8a226b9d43e6e080dc3e008a09426f0ef3eefe2bb369fdc6453'
AND (
token = 'HExsOz+buTjngWX+7iibXPS16cMk3Pugz+serM/Yomg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)