UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lxFghZDqXHptdv7XGouBZQ23npEEFpAOxE/v2gZ3hY4='
WHERE
key_id = '34b1cb4707bdfa3b5242abbb08911a4720cc2e6452e19b05166023875e5d61a9'
AND (
token = 'lxFghZDqXHptdv7XGouBZQ23npEEFpAOxE/v2gZ3hY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)