UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXnB8mVnCQa+v8liKaMuGmTGtl3kCSs+I729qb1IjVA='
WHERE
key_id = 'e386fde3060cfc8a03742700bb4f356b4e0476e8e1792ff75f88e016a1db0e59'
AND (
token = 'mXnB8mVnCQa+v8liKaMuGmTGtl3kCSs+I729qb1IjVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)