UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zWaYLmBhpK/6Yz5OOpYGUkeOvd0B2OdSWZTe/4JmuE='
WHERE
key_id = '3df865de519897cb8a837acf00ba9f4659c930f891c51623203b1916f193e884'
AND (
token = '0zWaYLmBhpK/6Yz5OOpYGUkeOvd0B2OdSWZTe/4JmuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)