UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9EfZ9TGdz4+ipS6vLY+NqZGC9QdC1RDm/L8PZefIlJk='
WHERE
key_id = 'd77912b1d2eceaf88a39090a2adf3814ac8877da7e8f53d96d8ee1252221c2c7'
AND (
token = '9EfZ9TGdz4+ipS6vLY+NqZGC9QdC1RDm/L8PZefIlJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)