UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJHPg1fOIruKHHoH6qCPhpLjpfJM9vsjwRVMX1hBzCI='
WHERE
key_id = '1bfac187c505ed76be4014da21b8ff4aa431a865c79b87e0cbb3fa4e6736c76b'
AND (
token = 'qJHPg1fOIruKHHoH6qCPhpLjpfJM9vsjwRVMX1hBzCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)