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