UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3/dUpcAxLMHHrIl4H9vJdTDmTvK1TzZUdt+4u/g2Cug='
WHERE
key_id = 'b9e99a0ef7b850faea1836cf99dff987b20b89020378fc05aeb43826ae825163'
AND (
token = '3/dUpcAxLMHHrIl4H9vJdTDmTvK1TzZUdt+4u/g2Cug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)