UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HtWYAuDnqe+ehKCWUTWgnn3uB9KpfcxSHEX/ZkaZ2Og='
WHERE
key_id = '570367f767095d2bdf3f13c3fa3cbbf940d5db0cc517c844a965d3f3b6ec8cb8'
AND (
token = 'HtWYAuDnqe+ehKCWUTWgnn3uB9KpfcxSHEX/ZkaZ2Og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)