UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0wD3f9KsWrwTYOEjL08sgmVLO4tRRbsqhPATbRT7L/8='
WHERE
key_id = 'c567f6b3fe442397b997703b5d29f8a2bddd40eb1b3782d9c828c74ebe19c6aa'
AND (
token = '0wD3f9KsWrwTYOEjL08sgmVLO4tRRbsqhPATbRT7L/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)