UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '319O6WiDqV2lYJU8/cVUorAK8I2G3YABvs+GW8kh3S8='
WHERE
key_id = 'e4787c71152875040e96931701766711cdb3e5a95420f92d5ae05b5045ee5c74'
AND (
token = '319O6WiDqV2lYJU8/cVUorAK8I2G3YABvs+GW8kh3S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)