UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gH94YWgvc2IXruoIj8g4WnGDSC+ElGq4az1FV9QJPaA='
WHERE
key_id = '712438cd3b7a164bd9109ed3fe92017108e8647b56be6e26dde9f95fede1bd4a'
AND (
token = 'gH94YWgvc2IXruoIj8g4WnGDSC+ElGq4az1FV9QJPaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)